update data profile

Dataset statistics

Number of variables	24
Number of observations	1950
Missing cells	10290
Missing cells (%)	22.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	365.8 KiB
Average record size in memory	192.1 B

Variable types

Numeric	15
Categorical	7
Unsupported	2

Alerts

`missing_value_latest` has constant value ""	Constant
`missing_value_update` has constant value ""	Constant
`time_type` is highly imbalanced (99.4%)	Imbalance
`stderr_latest` has 1594 (81.7%) missing values	Missing
`sample_size_latest` has 1601 (82.1%) missing values	Missing
`computation_as_of_dt_latest` has 1950 (100.0%) missing values	Missing
`stderr_update` has 1594 (81.7%) missing values	Missing
`sample_size_update` has 1601 (82.1%) missing values	Missing
`computation_as_of_dt_update` has 1950 (100.0%) missing values	Missing
`time_value` is highly skewed (γ1 = -44.14867533)	Skewed
`value_latest` is highly skewed (γ1 = 30.19017055)	Skewed
`issue_update` is highly skewed (γ1 = -44.15088754)	Skewed
`value_update` is highly skewed (γ1 = 30.19017055)	Skewed
`computation_as_of_dt_latest` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`computation_as_of_dt_update` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`value_latest` has 456 (23.4%) zeros	Zeros
`value_update` has 456 (23.4%) zeros	Zeros

Reproduction

Analysis started	2024-04-08 02:46:38.212598
Analysis finished	2024-04-08 02:46:49.118679
Duration	10.91 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

signal_key_id
Real number (ℝ)

Distinct	221
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108.72564

Minimum	1
Maximum	831
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	1
5-th percentile	34
Q1	51
median	70
Q3	96
95-th percentile	391.55
Maximum	831
Range	830
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	119.38063
Coefficient of variation (CV)	1.0979988
Kurtosis	10.662265
Mean	108.72564
Median Absolute Deviation (MAD)	20.5
Skewness	3.1480376
Sum	212015
Variance	14251.734
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	171	8.8%
69	157	8.1%
68	136	7.0%
48	122	6.3%
73	116	5.9%
51	63	3.2%
66	53	2.7%
70	48	2.5%
65	48	2.5%
71	43	2.2%
Other values (211)	993	50.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10	0.5%
2	7	0.4%
4	4	0.2%
7	1	0.1%
8	2	0.1%
9	2	0.1%
10	5	0.3%
12	3	0.2%
13	4	0.2%
14	2	0.1%

Value	Count	Frequency (%)
831	1	0.1%
823	1	0.1%
821	1	0.1%
819	1	0.1%
765	1	0.1%
764	1	0.1%
679	2	0.1%
674	1	0.1%
672	1	0.1%
671	1	0.1%

geo_key_id
Real number (ℝ)

Distinct	1513
Distinct (%)	77.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2018.9749

Minimum	6
Maximum	5406
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	6
5-th percentile	172
Q1	878.5
median	1815
Q3	2768
95-th percentile	4895.55
Maximum	5406
Range	5400
Interquartile range (IQR)	1889.5

Descriptive statistics

Standard deviation	1416.5606
Coefficient of variation (CV)	0.70162369
Kurtosis	-0.30595106
Mean	2018.9749
Median Absolute Deviation (MAD)	945
Skewness	0.71075382
Sum	3937001
Variance	2006643.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
684	6	0.3%
201	4	0.2%
2534	4	0.2%
2572	4	0.2%
3230	4	0.2%
809	4	0.2%
3083	3	0.2%
238	3	0.2%
2360	3	0.2%
8	3	0.2%
Other values (1503)	1912	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	1	0.1%
7	2	0.1%
8	3	0.2%
12	1	0.1%
14	2	0.1%
15	2	0.1%
18	2	0.1%
23	1	0.1%
26	1	0.1%
27	1	0.1%

Value	Count	Frequency (%)
5406	2	0.1%
5402	1	0.1%
5401	1	0.1%
5398	1	0.1%
5397	1	0.1%
5386	1	0.1%
5382	1	0.1%
5381	1	0.1%
5336	1	0.1%
5335	1	0.1%

time_type
Categorical

IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.4 KiB

day	1949
week	1

Length

Max length	4
Median length	3
Mean length	3.0005128
Min length	3

Characters and Unicode

Total characters	5851
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	day
2nd row	day
3rd row	day
4th row	day
5th row	day

Common Values

Value	Count	Frequency (%)
day	1949	99.9%
week	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
day	1949	99.9%
week	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
d	1949	33.3%
a	1949	33.3%
y	1949	33.3%
e	2	< 0.1%
w	1	< 0.1%
k	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5851	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
d	1949	33.3%
a	1949	33.3%
y	1949	33.3%
e	2	< 0.1%
w	1	< 0.1%
k	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5851	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
d	1949	33.3%
a	1949	33.3%
y	1949	33.3%
e	2	< 0.1%
w	1	< 0.1%
k	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5851	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
d	1949	33.3%
a	1949	33.3%
y	1949	33.3%
e	2	< 0.1%
w	1	< 0.1%
k	1	< 0.1%

time_value
Real number (ℝ)

SKEWED

Distinct	657
Distinct (%)	33.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20193929

Minimum	202026
Maximum	20220531
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	202026
5-th percentile	20200222
Q1	20200613
median	20201021
Q3	20210401
95-th percentile	20210902
Maximum	20220531
Range	20018505
Interquartile range (IQR)	9788

Descriptive statistics

Standard deviation	452994.35
Coefficient of variation (CV)	0.022432204
Kurtosis	1949.4033
Mean	20193929
Median Absolute Deviation (MAD)	603
Skewness	-44.148675
Sum	3.9378163 × 10¹⁰
Variance	2.0520388 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20200618	13	0.7%
20200622	11	0.6%
20200613	10	0.5%
20200611	9	0.5%
20200612	9	0.5%
20200623	8	0.4%
20200414	8	0.4%
20201002	8	0.4%
20200423	8	0.4%
20200527	8	0.4%
Other values (647)	1858	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
202026	1	0.1%
20190103	1	0.1%
20190105	1	0.1%
20190108	1	0.1%
20190111	1	0.1%
20190118	1	0.1%
20190120	1	0.1%
20190125	1	0.1%
20190126	1	0.1%
20190130	1	0.1%

Value	Count	Frequency (%)
20220531	1	0.1%
20220530	1	0.1%
20220528	1	0.1%
20220527	3	0.2%
20220518	3	0.2%
20220512	1	0.1%
20220509	1	0.1%
20220504	1	0.1%
20220425	1	0.1%
20220416	1	0.1%

issue_latest
Real number (ℝ)

Distinct	295
Distinct (%)	15.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20213328

Minimum	20200514
Maximum	20220822
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	20200514
5-th percentile	20200830
Q1	20201229
median	20220801
Q3	20220811
95-th percentile	20220820
Maximum	20220822
Range	20308
Interquartile range (IQR)	19582

Descriptive statistics

Standard deviation	8315.2601
Coefficient of variation (CV)	0.00041137511
Kurtosis	-1.4326442
Mean	20213328
Median Absolute Deviation (MAD)	20
Skewness	-0.46824495
Sum	3.941599 × 10¹⁰
Variance	69143551
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20201030	153	7.8%
20220821	70	3.6%
20200825	67	3.4%
20220801	59	3.0%
20201014	58	3.0%
20220815	53	2.7%
20220807	51	2.6%
20220805	50	2.6%
20220802	50	2.6%
20220812	50	2.6%
Other values (285)	1289	66.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20200514	2	0.1%
20200523	2	0.1%
20200620	5	0.3%
20200623	11	0.6%
20200701	1	0.1%
20200709	2	0.1%
20200710	5	0.3%
20200730	1	0.1%
20200825	67	3.4%
20200829	2	0.1%

Value	Count	Frequency (%)
20220822	10	0.5%
20220821	70	3.6%
20220820	50	2.6%
20220819	43	2.2%
20220818	47	2.4%
20220817	29	1.5%
20220816	43	2.2%
20220815	53	2.7%
20220814	45	2.3%
20220813	46	2.4%

value_latest
Real number (ℝ)

SKEWED ZEROS

Distinct	1288
Distinct (%)	66.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	978.05284

Minimum	-2.1428571
Maximum	340882.01
Zeros	456
Zeros (%)	23.4%
Negative	7
Negative (%)	0.4%
Memory size	15.4 KiB

Quantile statistics

Minimum	-2.1428571
5-th percentile	0
Q1	0.040093664
median	2.2548675
Q3	50.192292
95-th percentile	5342.009
Maximum	340882.01
Range	340884.15
Interquartile range (IQR)	50.152198

Descriptive statistics

Standard deviation	9120.4606
Coefficient of variation (CV)	9.3251205
Kurtosis	1051.0108
Mean	978.05284
Median Absolute Deviation (MAD)	2.2548675
Skewness	30.190171
Sum	1907203
Variance	83182801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	456	23.4%
1	29	1.5%
0.1428571	19	1.0%
0.1428571429	18	0.9%
2	17	0.9%
0.2857142857	10	0.5%
0.4285714	8	0.4%
0.7142857	8	0.4%
4	7	0.4%
5	7	0.4%
Other values (1278)	1371	70.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2.142857143	2	0.1%
-1.581327683	1	0.1%
-0.8571429	1	0.1%
-0.7113336795	1	0.1%
-0.2857143	1	0.1%
-0.2857142857	1	0.1%
0	456	23.4%
0.005062965267	1	0.1%
0.007039712802	1	0.1%
0.0160253	1	0.1%

Value	Count	Frequency (%)
340882.0109	1	0.1%
167947.1874	1	0.1%
81852.71429	1	0.1%
30070.67938	1	0.1%
24169.42857	1	0.1%
22624	1	0.1%
18976	1	0.1%
17487.12805	1	0.1%
17082.48887	1	0.1%
16950.71396	1	0.1%

stderr_latest
Real number (ℝ)

MISSING

Distinct	356
Distinct (%)	100.0%
Missing	1594
Missing (%)	81.7%
Infinite	0
Infinite (%)	0.0%
Mean	3.4790508

Minimum	0
Maximum	83.606519
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0017151554
Q1	0.01609597
median	1.3661809
Q3	2.9301274
95-th percentile	18.909053
Maximum	83.606519
Range	83.606519
Interquartile range (IQR)	2.9140314

Descriptive statistics

Standard deviation	8.4947977
Coefficient of variation (CV)	2.4416999
Kurtosis	38.157454
Mean	3.4790508
Median Absolute Deviation (MAD)	1.3555063
Skewness	5.4846029
Sum	1238.5421
Variance	72.161589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.2843556	1	0.1%
2.4224529	1	0.1%
2.5321083	1	0.1%
2.83466	1	0.1%
2.5080232	1	0.1%
1.5967027	1	0.1%
0.008686757126	1	0.1%
2.1665719	1	0.1%
0.004849622805	1	0.1%
3.2343489	1	0.1%
Other values (346)	346	17.7%
(Missing)	1594	81.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
0.0001664096064	1	0.1%
0.0004438904029	1	0.1%
0.0004696946969	1	0.1%
0.000676382329	1	0.1%
0.0007468	1	0.1%
0.0009132956653	1	0.1%
0.0009655601197	1	0.1%
0.0011286	1	0.1%
0.001172784511	1	0.1%

Value	Count	Frequency (%)
83.60651888	1	0.1%
71.649843	1	0.1%
47.88811129	1	0.1%
45.6118803	1	0.1%
36.63887939	1	0.1%
34.86947944	1	0.1%
29.52848758	1	0.1%
29.12461776	1	0.1%
27.52026395	1	0.1%
26.96119419	1	0.1%

sample_size_latest
Real number (ℝ)

MISSING

Distinct	302
Distinct (%)	86.5%
Missing	1601
Missing (%)	82.1%
Infinite	0
Infinite (%)	0.0%
Mean	1169.0083

Minimum	2
Maximum	110162
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	2
5-th percentile	13.742
Q1	105.8527
median	197.6397
Q3	402.5647
95-th percentile	3117.377
Maximum	110162
Range	110160
Interquartile range (IQR)	296.712

Descriptive statistics

Standard deviation	7375.4926
Coefficient of variation (CV)	6.3091875
Kurtosis	169.96009
Mean	1169.0083
Median Absolute Deviation (MAD)	127.6397
Skewness	12.609181
Sum	407983.9
Variance	54397891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
112	5	0.3%
70	4	0.2%
189	4	0.2%
15	4	0.2%
8	4	0.2%
49	3	0.2%
196	3	0.2%
84	3	0.2%
14	3	0.2%
42	3	0.2%
Other values (292)	313	16.1%
(Missing)	1601	82.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2	0.1%
4	1	0.1%
5	1	0.1%
5.57	1	0.1%
6	3	0.2%
7	1	0.1%
8	4	0.2%
10	1	0.1%
11	2	0.1%
13	1	0.1%

Value	Count	Frequency (%)
110162	1	0.1%
77398	1	0.1%
18871	1	0.1%
18292	1	0.1%
11641	1	0.1%
9158	1	0.1%
7495	1	0.1%
6808	1	0.1%
5348.9975	1	0.1%
5108	1	0.1%

lag_latest
Real number (ℝ)

Distinct	344
Distinct (%)	17.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.085641

Minimum	1
Maximum	734
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	41
Q3	129
95-th percentile	322.85
Maximum	734
Range	733
Interquartile range (IQR)	128

Descriptive statistics

Standard deviation	119.42815
Coefficient of variation (CV)	1.4203157
Kurtosis	7.4121186
Mean	84.085641
Median Absolute Deviation (MAD)	40
Skewness	2.4378187
Sum	163967
Variance	14263.084
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	501	25.7%
5	124	6.4%
2	80	4.1%
3	56	2.9%
73	20	1.0%
4	20	1.0%
64	12	0.6%
12	12	0.6%
97	12	0.6%
49	11	0.6%
Other values (334)	1102	56.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	501	25.7%
2	80	4.1%
3	56	2.9%
4	20	1.0%
5	124	6.4%
6	10	0.5%
7	3	0.2%
8	7	0.4%
9	6	0.3%
10	7	0.4%

Value	Count	Frequency (%)
734	1	0.1%
732	1	0.1%
725	1	0.1%
719	1	0.1%
711	1	0.1%
707	1	0.1%
692	1	0.1%
687	1	0.1%
679	1	0.1%
673	1	0.1%

value_updated_timestamp_latest
Real number (ℝ)

Distinct	1863
Distinct (%)	95.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6117274 × 10⁹

Minimum	1.5893888 × 10⁹
Maximum	1.6611971 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	1.5893888 × 10⁹
5-th percentile	1.5983709 × 10⁹
Q1	1.6041087 × 10⁹
median	1.6085043 × 10⁹
Q3	1.6197766 × 10⁹
95-th percentile	1.6317247 × 10⁹
Maximum	1.6611971 × 10⁹
Range	71808300
Interquartile range (IQR)	15667903

Descriptive statistics

Standard deviation	11588509
Coefficient of variation (CV)	0.0071901174
Kurtosis	1.6863185
Mean	1.6117274 × 10⁹
Median Absolute Deviation (MAD)	5778162
Skewness	1.0270581
Sum	3.1428684 × 10¹²
Variance	1.3429354 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1604109395	3	0.2%
1598372949	3	0.2%
1623163921	3	0.2%
1604113707	3	0.2%
1610896544	3	0.2%
1604108064	2	0.1%
1620399112	2	0.1%
1609729455	2	0.1%
1604108068	2	0.1%
1598370038	2	0.1%
Other values (1853)	1925	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1589388807	1	0.1%
1589388916	1	0.1%
1589388926	1	0.1%
1589388997	1	0.1%
1589389060	1	0.1%
1589389166	1	0.1%
1590166272	1	0.1%
1590166275	1	0.1%
1591658520	1	0.1%
1592347926	1	0.1%

Value	Count	Frequency (%)
1661197107	1	0.1%
1661197099	1	0.1%
1661197064	1	0.1%
1661196699	1	0.1%
1661196560	1	0.1%
1661196558	1	0.1%
1661196554	1	0.1%
1661196489	1	0.1%
1661196282	1	0.1%
1661196211	1	0.1%

computation_as_of_dt_latest
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	1950
Missing (%)	100.0%
Memory size	15.4 KiB

missing_value_latest
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.4 KiB

0	1950

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1950
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1950	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1950	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1950	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1950	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1950	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1950	100.0%

missing_stderr_latest
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.4 KiB

5	1594
0	356

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1950
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	0
3rd row	0
4th row	5
5th row	5

Common Values

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Most occurring characters

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

missing_sample_size_latest
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.4 KiB

5	1601
0	349

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1950
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	0
3rd row	0
4th row	5
5th row	5

Common Values

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Most occurring characters

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

issue_update
Real number (ℝ)

SKEWED

Distinct	372
Distinct (%)	19.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20195426

Minimum	202107
Maximum	20220822
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	202107
5-th percentile	20200825
Q1	20201030
median	20201220
Q3	20210428
95-th percentile	20210915
Maximum	20220822
Range	20018715
Interquartile range (IQR)	9398

Descriptive statistics

Standard deviation	453018.87
Coefficient of variation (CV)	0.022431756
Kurtosis	1949.5337
Mean	20195426
Median Absolute Deviation (MAD)	596.5
Skewness	-44.150888
Sum	3.9381081 × 10¹⁰
Variance	2.052261 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20201030	289	14.8%
20200825	121	6.2%
20201014	118	6.1%
20201112	63	3.2%
20201017	49	2.5%
20210106	43	2.2%
20200623	27	1.4%
20210916	24	1.2%
20210221	23	1.2%
20210907	23	1.2%
Other values (362)	1170	60.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
202107	1	0.1%
20200514	6	0.3%
20200523	2	0.1%
20200528	1	0.1%
20200609	1	0.1%
20200617	1	0.1%
20200620	9	0.5%
20200623	27	1.4%
20200630	1	0.1%
20200701	1	0.1%

Value	Count	Frequency (%)
20220822	15	0.8%
20220812	4	0.2%
20210930	3	0.2%
20210929	3	0.2%
20210928	6	0.3%
20210927	5	0.3%
20210926	6	0.3%
20210925	2	0.1%
20210924	3	0.2%
20210923	6	0.3%

value_update
Real number (ℝ)

SKEWED ZEROS

Distinct	1288
Distinct (%)	66.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	978.05284

Minimum	-2.1428571
Maximum	340882.01
Zeros	456
Zeros (%)	23.4%
Negative	7
Negative (%)	0.4%
Memory size	15.4 KiB

Quantile statistics

Minimum	-2.1428571
5-th percentile	0
Q1	0.040093664
median	2.2548675
Q3	50.192292
95-th percentile	5342.009
Maximum	340882.01
Range	340884.15
Interquartile range (IQR)	50.152198

Descriptive statistics

Standard deviation	9120.4606
Coefficient of variation (CV)	9.3251205
Kurtosis	1051.0108
Mean	978.05284
Median Absolute Deviation (MAD)	2.2548675
Skewness	30.190171
Sum	1907203
Variance	83182801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	456	23.4%
1	29	1.5%
0.1428571	19	1.0%
0.1428571429	18	0.9%
2	17	0.9%
0.2857142857	10	0.5%
0.4285714	8	0.4%
0.7142857	8	0.4%
4	7	0.4%
5	7	0.4%
Other values (1278)	1371	70.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2.142857143	2	0.1%
-1.581327683	1	0.1%
-0.8571429	1	0.1%
-0.7113336795	1	0.1%
-0.2857143	1	0.1%
-0.2857142857	1	0.1%
0	456	23.4%
0.005062965267	1	0.1%
0.007039712802	1	0.1%
0.0160253	1	0.1%

Value	Count	Frequency (%)
340882.0109	1	0.1%
167947.1874	1	0.1%
81852.71429	1	0.1%
30070.67938	1	0.1%
24169.42857	1	0.1%
22624	1	0.1%
18976	1	0.1%
17487.12805	1	0.1%
17082.48887	1	0.1%
16950.71396	1	0.1%

stderr_update
Real number (ℝ)

MISSING

Distinct	356
Distinct (%)	100.0%
Missing	1594
Missing (%)	81.7%
Infinite	0
Infinite (%)	0.0%
Mean	3.4790508

Minimum	0
Maximum	83.606519
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0017151554
Q1	0.01609597
median	1.3661809
Q3	2.9301274
95-th percentile	18.909053
Maximum	83.606519
Range	83.606519
Interquartile range (IQR)	2.9140314

Descriptive statistics

Standard deviation	8.4947977
Coefficient of variation (CV)	2.4416999
Kurtosis	38.157454
Mean	3.4790508
Median Absolute Deviation (MAD)	1.3555063
Skewness	5.4846029
Sum	1238.5421
Variance	72.161589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.2843556	1	0.1%
2.4224529	1	0.1%
2.5321083	1	0.1%
2.83466	1	0.1%
2.5080232	1	0.1%
1.5967027	1	0.1%
0.008686757126	1	0.1%
2.1665719	1	0.1%
0.004849622805	1	0.1%
3.2343489	1	0.1%
Other values (346)	346	17.7%
(Missing)	1594	81.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
0.0001664096064	1	0.1%
0.0004438904029	1	0.1%
0.0004696946969	1	0.1%
0.000676382329	1	0.1%
0.0007468	1	0.1%
0.0009132956653	1	0.1%
0.0009655601197	1	0.1%
0.0011286	1	0.1%
0.001172784511	1	0.1%

Value	Count	Frequency (%)
83.60651888	1	0.1%
71.649843	1	0.1%
47.88811129	1	0.1%
45.6118803	1	0.1%
36.63887939	1	0.1%
34.86947944	1	0.1%
29.52848758	1	0.1%
29.12461776	1	0.1%
27.52026395	1	0.1%
26.96119419	1	0.1%

sample_size_update
Real number (ℝ)

MISSING

Distinct	302
Distinct (%)	86.5%
Missing	1601
Missing (%)	82.1%
Infinite	0
Infinite (%)	0.0%
Mean	1169.0083

Minimum	2
Maximum	110162
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	2
5-th percentile	13.742
Q1	105.8527
median	197.6397
Q3	402.5647
95-th percentile	3117.377
Maximum	110162
Range	110160
Interquartile range (IQR)	296.712

Descriptive statistics

Standard deviation	7375.4926
Coefficient of variation (CV)	6.3091875
Kurtosis	169.96009
Mean	1169.0083
Median Absolute Deviation (MAD)	127.6397
Skewness	12.609181
Sum	407983.9
Variance	54397891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
112	5	0.3%
70	4	0.2%
189	4	0.2%
15	4	0.2%
8	4	0.2%
49	3	0.2%
196	3	0.2%
84	3	0.2%
14	3	0.2%
42	3	0.2%
Other values (292)	313	16.1%
(Missing)	1601	82.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2	0.1%
4	1	0.1%
5	1	0.1%
5.57	1	0.1%
6	3	0.2%
7	1	0.1%
8	4	0.2%
10	1	0.1%
11	2	0.1%
13	1	0.1%

Value	Count	Frequency (%)
110162	1	0.1%
77398	1	0.1%
18871	1	0.1%
18292	1	0.1%
11641	1	0.1%
9158	1	0.1%
7495	1	0.1%
6808	1	0.1%
5348.9975	1	0.1%
5108	1	0.1%

lag_update
Real number (ℝ)

Distinct	344
Distinct (%)	17.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.085641

Minimum	1
Maximum	734
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	41
Q3	129
95-th percentile	322.85
Maximum	734
Range	733
Interquartile range (IQR)	128

Descriptive statistics

Standard deviation	119.42815
Coefficient of variation (CV)	1.4203157
Kurtosis	7.4121186
Mean	84.085641
Median Absolute Deviation (MAD)	40
Skewness	2.4378187
Sum	163967
Variance	14263.084
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	501	25.7%
5	124	6.4%
2	80	4.1%
3	56	2.9%
73	20	1.0%
4	20	1.0%
64	12	0.6%
12	12	0.6%
97	12	0.6%
49	11	0.6%
Other values (334)	1102	56.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	501	25.7%
2	80	4.1%
3	56	2.9%
4	20	1.0%
5	124	6.4%
6	10	0.5%
7	3	0.2%
8	7	0.4%
9	6	0.3%
10	7	0.4%

Value	Count	Frequency (%)
734	1	0.1%
732	1	0.1%
725	1	0.1%
719	1	0.1%
711	1	0.1%
707	1	0.1%
692	1	0.1%
687	1	0.1%
679	1	0.1%
673	1	0.1%

value_updated_timestamp_update
Real number (ℝ)

Distinct	1863
Distinct (%)	95.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6117274 × 10⁹

Minimum	1.5893888 × 10⁹
Maximum	1.6611971 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.4 KiB

Quantile statistics

Minimum	1.5893888 × 10⁹
5-th percentile	1.5983709 × 10⁹
Q1	1.6041087 × 10⁹
median	1.6085043 × 10⁹
Q3	1.6197766 × 10⁹
95-th percentile	1.6317247 × 10⁹
Maximum	1.6611971 × 10⁹
Range	71808300
Interquartile range (IQR)	15667903

Descriptive statistics

Standard deviation	11588509
Coefficient of variation (CV)	0.0071901174
Kurtosis	1.6863185
Mean	1.6117274 × 10⁹
Median Absolute Deviation (MAD)	5778162
Skewness	1.0270581
Sum	3.1428684 × 10¹²
Variance	1.3429354 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1604109395	3	0.2%
1598372949	3	0.2%
1623163921	3	0.2%
1604113707	3	0.2%
1610896544	3	0.2%
1604108064	2	0.1%
1620399112	2	0.1%
1609729455	2	0.1%
1604108068	2	0.1%
1598370038	2	0.1%
Other values (1853)	1925	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1589388807	1	0.1%
1589388916	1	0.1%
1589388926	1	0.1%
1589388997	1	0.1%
1589389060	1	0.1%
1589389166	1	0.1%
1590166272	1	0.1%
1590166275	1	0.1%
1591658520	1	0.1%
1592347926	1	0.1%

Value	Count	Frequency (%)
1661197107	1	0.1%
1661197099	1	0.1%
1661197064	1	0.1%
1661196699	1	0.1%
1661196560	1	0.1%
1661196558	1	0.1%
1661196554	1	0.1%
1661196489	1	0.1%
1661196282	1	0.1%
1661196211	1	0.1%

computation_as_of_dt_update
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	1950
Missing (%)	100.0%
Memory size	15.4 KiB

missing_value_update
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.4 KiB

0	1950

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1950
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1950	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1950	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1950	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1950	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1950	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1950	100.0%

missing_stderr_update
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.4 KiB

5	1594
0	356

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1950
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	0
3rd row	0
4th row	5
5th row	5

Common Values

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Most occurring characters

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	1594	81.7%
0	356	18.3%

missing_sample_size_update
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.4 KiB

5	1601
0	349

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1950
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	0
3rd row	0
4th row	5
5th row	5

Common Values

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Most occurring characters

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1950	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	1601	82.1%
0	349	17.9%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	signal_key_id	geo_key_id	time_type	time_value	issue_latest	value_latest	stderr_latest	sample_size_latest	lag_latest	value_updated_timestamp_latest	computation_as_of_dt_latest	missing_stderr_latest	missing_sample_size_latest	issue_update	value_update	stderr_update	sample_size_update	lag_update	value_updated_timestamp_update	computation_as_of_dt_update	missing_stderr_update	missing_sample_size_update
0	1	250	day	20220512	20220822	0.871166	NaN	NaN	102	1661196211	NaN	5	5	20220822	0.871166	NaN	NaN	102	1661196211	NaN	5	5
1	178	610	day	20190818	20220802	0.103981	0.006896	84.0	507	1609973490	NaN	0	0	20210106	0.103981	0.006896	84.0	507	1609973490	NaN	0	0
2	176	4741	day	20190613	20220811	0.048802	0.005053	49.0	573	1609973321	NaN	0	0	20210106	0.048802	0.005053	49.0	573	1609973321	NaN	0	0
3	29	2121	day	20210313	20210316	9.285714	NaN	NaN	3	1615942270	NaN	5	5	20210316	9.285714	NaN	NaN	3	1615942270	NaN	5	5
4	96	1577	day	20210306	20210308	70.463985	NaN	NaN	2	1615229122	NaN	5	5	20210308	70.463985	NaN	NaN	2	1615229122	NaN	5	5
5	69	817	day	20200421	20201030	0.571429	NaN	NaN	192	1604108117	NaN	5	5	20201030	0.571429	NaN	NaN	192	1604108117	NaN	5	5
6	73	1088	day	20210726	20220803	0.142857	NaN	NaN	1	1627392747	NaN	5	5	20210727	0.142857	NaN	NaN	1	1627392747	NaN	5	5
7	104	4789	day	20200613	20201017	3.955070	NaN	NaN	126	1602950850	NaN	5	5	20201017	3.955070	NaN	NaN	126	1602950850	NaN	5	5
8	68	981	day	20210302	20220815	5329.938941	NaN	NaN	1	1614783061	NaN	5	5	20210303	5329.938941	NaN	NaN	1	1614783061	NaN	5	5
9	46	1918	day	20200512	20220806	38.000000	NaN	NaN	105	1598371292	NaN	5	5	20200825	38.000000	NaN	NaN	105	1598371292	NaN	5	5

	signal_key_id	geo_key_id	time_type	time_value	issue_latest	value_latest	stderr_latest	sample_size_latest	lag_latest	value_updated_timestamp_latest	computation_as_of_dt_latest	missing_stderr_latest	missing_sample_size_latest	issue_update	value_update	stderr_update	sample_size_update	lag_update	value_updated_timestamp_update	computation_as_of_dt_update	missing_stderr_update	missing_sample_size_update
1940	46	83	day	20200713	20220820	3346.000000	NaN	NaN	93	1602729075	NaN	5	5	20201014	3346.000000	NaN	NaN	93	1602729075	NaN	5	5
1941	819	798	day	20220509	20220822	0.995000	NaN	NaN	105	1661196489	NaN	5	5	20220822	0.995000	NaN	NaN	105	1661196489	NaN	5	5
1942	177	1041	day	20190526	20220818	469.375000	21.223969	56.000	591	1609973274	NaN	0	0	20210106	469.375000	21.223969	56.000	591	1609973274	NaN	0	0
1943	49	1096	day	20200414	20220815	0.000000	NaN	NaN	133	1598370160	NaN	5	5	20200825	0.000000	NaN	NaN	133	1598370160	NaN	5	5
1944	381	1658	day	20220528	20220822	52.986737	4.667591	114.341	86	1661196282	NaN	0	0	20220822	52.986737	4.667591	114.341	86	1661196282	NaN	0	0
1945	97	2163	day	20200511	20201017	0.000000	NaN	NaN	159	1602950499	NaN	5	5	20201017	0.000000	NaN	NaN	159	1602950499	NaN	5	5
1946	68	4653	day	20210718	20220801	9844.402259	NaN	NaN	1	1626688300	NaN	5	5	20210719	9844.402259	NaN	NaN	1	1626688300	NaN	5	5
1947	103	4516	day	20200518	20220819	4.000000	NaN	NaN	152	1602950571	NaN	5	5	20201017	4.000000	NaN	NaN	152	1602950571	NaN	5	5
1948	92	2709	day	20210326	20220802	9149.392423	NaN	NaN	2	1616958191	NaN	5	5	20210328	9149.392423	NaN	NaN	2	1616958191	NaN	5	5
1949	41	99	day	20200528	20201112	0.000000	NaN	NaN	168	1605173742	NaN	5	5	20201112	0.000000	NaN	NaN	168	1605173742	NaN	5	5

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)